GL transaction data file specifications

General file specifications

File Specification	Description
Number of Periods	Multiple transaction days up to one year of data. Typically, your organization provides this file monthly, though some clients load data more often due to the size of these files.
Column Names	This column can include or exclude column names in the first row data file.
File Type	.txt and .csv
Delimiters	The comma, pipe, period, space, tab, semicolon, colon are most common. The pipe delimiter is preferred due to the rarity of the pipe symbol occurrence within financial data.

Column Specifications

Column Name	Column Data Type	Primary Key	Description
NativeTranCode	Integer	Yes	The Native GL transaction code.
ACCT	Integer	No	The account number found in the general ledger chart of accounts.
Company	Integer	No	The general ledger company number.
DEPT	Integer	No	The general ledger department number.
BatchID	Integer	No	The journal entry batch ID.
JournalDesc	String(50)	No	The debit or credit entry. Acceptable values include DR (debit) and CR (credit).
EffDate	Date	No	The transaction effective date.
PostDate	Date	No	The transaction posting date.
UserID	String(10)	No	The general ledger user ID.
NatBal	Numeric	No	The transaction amount.